Notes/Domino 6 and 7 Forum : displaying data from multiple notes DB's on one view -- HELP!

Hi,

Hopefully someone on this board can give me a little direction -- I've been beating my head against a wall over this for a week now, and I need this project to be done yesterday, basically. (I posted this on the "Enterprise Integration" forum, but if anyone on this forum has some possible solutions for my dilemma, I'm definitely listening!)

Essentially, what I'm trying to do is create a view that's categorized for multiple columns, and displays various data from four different Notes databases. To do this, I tried using LEI and the "Virtual Fields" Notes RealTime features available with version 6.5. What I designed was a series of Virtual Fields activities that generated initial key data, used that key data as keys to find data from the second Notes database in the next activity, etc., and displayed all of those documents in a view in my target Notes dtaabase. I used NotesSQL to set up ODBC connections for my various source Notes DB's, and created ODBC activity documents that drew from those sources. This seems to be what the LEI help documentation suggests, although it is vague when describing how to implement this solution (or I just don't get what it's trying to tell me, whichever).

I've come across several problems using this method:

(1) Virtual fields do not display in views. The best I could do with these fields is to initialize the key documents, run all of the activities to get the field values into the documents, copy the live documents to another Notes database (*very* time-intensive process), stop the activities, delete the original documents in the target database, and copy the docs from the outside database back into the target database. However, it's not even a good hack, since when I turn the activity documents back on, the fields are unavailable to the view again. =(

(2) A few of the fields I draw with my initial keys are multi-value fields, and I need to pull data from the other source databases based on each of the values in the multi-data fields. I tried checking the option "Use multi-value data fields" to accomplish this, but I still can't draw data for *any* of the values in those fields.

(3) I think Virtual Documents might work for what I want to do, but when I tried to set up a Virtual Document activity, I got the following error message:

"The Connector table does not contain the correct columns, or contains the wrong datatypes for use with Virtual Document activities. The following columns are missing or incorrect: EIMODIFIED, EINOTESPROPS, EIUNID, EINOTEID."

Are these fields I should set up in the source databases, or the target database, or both? How do I set them up so that my activity document recognizes these fields? I tried looking in the Help documentation for these answers, but it wasn't very clear.

(4) Is there a possible solution outside of LEI and NotesSQL that might work for what I want to do? I tried a WebQueryOpen agent that does Notes searches based on the key values above, and outputs the HTML-formatted results to my browser, but I ran into a brick wall when trying to make my results categorized by multiple columns.

Sorry to ramble, but that's probably my frustration talking. If someone could help me with any or all of these issues, I would *greatly* appreciate it. I'm so much up against a deadline that it isn't funny.

Thanks in advance!

Sam